[dbo].[EventRegistrationAnswer]

Property	Value
Created	10:31:20 AM Tuesday, March 02, 2010
Last Modified	11:40:02 AM Monday, February 20, 2012

Property

Value

Created

10:31:20 AM Tuesday, March 02, 2010

Last Modified

11:40:02 AM Monday, February 20, 2012

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_EventRegistrationAnswer: EventCode\RegistrantID\QuestionID$ $Foreign Keys FK_EventRegistrantAnswer_EventRegistrant: [dbo].[EventRegistrant].RegistrantID\EventCode$	RegistrantID	varchar(10)	10
$Cluster Primary Key PK_EventRegistrationAnswer: EventCode\RegistrantID\QuestionID$ $Foreign Keys FK_EventRegistrantAnswer_EventRegistrant: [dbo].[EventRegistrant].RegistrantID\EventCode$	EventCode	varchar(15)	15
$Cluster Primary Key PK_EventRegistrationAnswer: EventCode\RegistrantID\QuestionID$	QuestionID	int	4
	Answer	varchar(512)	512

Name

Data Type

Max Length (Bytes)

Allow Nulls

$Cluster Primary Key PK_EventRegistrationAnswer: EventCode\RegistrantID\QuestionID$ $Foreign Keys FK_EventRegistrantAnswer_EventRegistrant: [dbo].[EventRegistrant].RegistrantID\EventCode$

RegistrantID

varchar(10)

$Cluster Primary Key PK_EventRegistrationAnswer: EventCode\RegistrantID\QuestionID$ $Foreign Keys FK_EventRegistrantAnswer_EventRegistrant: [dbo].[EventRegistrant].RegistrantID\EventCode$

EventCode

varchar(15)

$Cluster Primary Key PK_EventRegistrationAnswer: EventCode\RegistrantID\QuestionID$

QuestionID

int

Answer

varchar(512)

512

	Name	Columns	Unique
$Cluster Primary Key PK_EventRegistrationAnswer: EventCode\RegistrantID\QuestionID$	PK_EventRegistrationAnswer	EventCode, RegistrantID, QuestionID

Name

Columns

Unique

$Cluster Primary Key PK_EventRegistrationAnswer: EventCode\RegistrantID\QuestionID$

PK_EventRegistrationAnswer

EventCode, RegistrantID, QuestionID

Name	Delete	Columns
FK_EventRegistrantAnswer_EventRegistrant	Cascade	RegistrantID->[dbo].[EventRegistrant].[RegistrantID] EventCode->[dbo].[EventRegistrant].[EventCode]
FK_EventRegistrationAnswer_EventSetupQuestion		QuestionID->[dbo].[EventSetupQuestion].[EventSetupQuestionID]

Name

Delete

Columns

FK_EventRegistrantAnswer_EventRegistrant

Cascade

RegistrantID->[dbo].[EventRegistrant].[RegistrantID]
EventCode->[dbo].[EventRegistrant].[EventCode]

FK_EventRegistrationAnswer_EventSetupQuestion

QuestionID->[dbo].[EventSetupQuestion].[EventSetupQuestionID]

SQL Script

CREATE TABLE [dbo].[EventRegistrationAnswer]
(
[RegistrantID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EventCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[QuestionID] [int] NOT NULL,
[Answer] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[EventRegistrationAnswer] ADD CONSTRAINT [PK_EventRegistrationAnswer] PRIMARY KEY CLUSTERED ([EventCode], [RegistrantID], [QuestionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[EventRegistrationAnswer] ADD CONSTRAINT [FK_EventRegistrantAnswer_EventRegistrant] FOREIGN KEY ([RegistrantID], [EventCode]) REFERENCES [dbo].[EventRegistrant] ([RegistrantID], [EventCode]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[EventRegistrationAnswer] ADD CONSTRAINT [FK_EventRegistrationAnswer_EventSetupQuestion] FOREIGN KEY ([QuestionID]) REFERENCES [dbo].[EventSetupQuestion] ([EventSetupQuestionID])
GO